Search for: All records

Comparing relational languages by their logical expressiveness is well understood. Less understood is how to compare relational languages by their ability to represent relational query patterns. Indeed, what are query patterns other than ''a certain way of writing a query''? And how can query patterns be defined across procedural and declarative languages, irrespective of their syntax? Our SIGMOD 2024 paper proposes a semantic definition of relational query patterns that uses a variant of structure-preserving mappings between the relational tables of queries. This formalism allows us to analyze the relative pattern expressiveness of relational languages. Notably, for the nondisjunctive language fragment, we show that relational calculus (RC) can express a larger class of patterns than the basic operators of relational algebra (RA). We also propose Relational Diagrams, a complete and sound diagrammatic representation of safe relational calculus. These diagrams can represent all query patterns for unions of non-disjunctive queries, in contrast to visual query representations that derive visual marks from the basic operators of algebra. Our anonymously preregistered user study shows that Relational Diagrams allow users to recognize relational patterns meaningfully faster and more accurately than they can with SQL. 

Abstract Laser ablation is a process that bears both fundamental physics interest and has wide industrial applications. For decades, the lack of probes on the relevant time and length scales has prevented access to the highly nonequilibrium phase decomposition processes triggered by laser excitation. In this study, a close integration of time-resolved probing by intense femtosecond X-ray pulses with large-scale atomistic modeling has yielded unique insights into the ablation dynamics of thin gold films irradiated by femtosecond laser pulses. The emergence and growth of nanoscale density heterogeneities in the expanding ablation plume, predicted in the simulations, are mapped to the rapid evolution of distinct small angle diffraction features. This mapping enables identification of the characteristic signatures of different phase decomposition processes occurring simultaneously in the plume, which are driven by photomechanical and thermodynamic driving forces. Beyond the specific insights into the ablation phenomenon, this study demonstrates the power of joint X-ray probing and atomistic modeling of material dynamics under extreme conditions of thermal and mechanical nonequilibrium. 

The Mississippi River Basin (MRB), the fourth-largest river basin in the world, is an important corridor for hy- droelectric power generation, agricultural and industrial production, riverine transportation, and ecosystem goods and services. Historically, flooding of the Mississippi River has resulted in significant economic losses. In a future with an intensified global hydrological cycle, the altered discharge of the river may jeopardize commu- nities and infrastructure situated in the floodplain. This study utilizes output from the Community Earth System Model version 2 (CESM2) large ensemble simulations spanning 1930 to 2100 to quantify changes in future MRB discharge under a high greenhouse gas emissions scenario (SSP3–7.0). The simulations show that increasing precipitation trends exceed and dominate increased evapotranspiration (ET), driving an overall increase in total discharge in the Ohio and Lower Mississippi River basins. On a seasonal scale, reduced spring snowmelt is projected in the Ohio and Missouri River basins, leading to reduced spring runoff in those regions. However, decreased snowmelt and spring runoff is overshadowed by a larger increase in projected precipitation minus ET over the entire basin and leads to an increase in mean river discharge. This increase in discharge is linked to a relatively small increase in the magnitude of extreme floods (2 % and 3 % for 100-year and 1000-year floods, respectively) by the late 21st century relative to the late 20th century. Our analyses imply that under SSP3–7.0 forcing, the Mississippi River and Tributaries (MR&T) project design flood would not be exceeded at the 100-year return period. Our results harbor implications for water resources management including increased vulnerability of the Mississippi River given projected changes in climate. 

The notion of climate sensitivity has become synonymous with equilibrium climate sensitivity (ECS), or the equilibrium response of the Earth system to a doubling of CO₂. But there is a hierarchy of measures of climate sensitivity, which can be arranged in order of increasing complexity and societal relevance and which mirror the historical development of climate modeling. Elements of this hierarchy include the well-known ECS and transient climate response and the lesser-known transient climate response to cumulative emissions and zero emissions commitment. This article describes this hierarchy of climate sensitivities and associated modeling approaches. Key concepts reviewed along the way include climate forcing and feedback, ocean heat uptake, and the airborne fraction of cumulative emissions. We employ simplified theoretical models throughout to encapsulate well-understood aspects of these quantities and to highlight gaps in our understanding and areas for future progress.▪There is a hierarchy of measures of climate sensitivity, which exhibit a range of complexity and societal relevance.▪Equilibrium climate sensitivity is only one of these measures, and our understanding of it may have reached a plateau.▪The more complex measures introduce new quantities, such as ocean heat uptake coefficient and airborne fraction, which deserve increased attention.